Tabela PhStItemBundleItem

Definicja tabeli PhStItemBundleItem

Name

PhStItemBundleItem

Code

PhStItemBundleItem

Comment

Tabela przechowuje packageId przychodzacy z Unitdose i laczy go z pozycja zlecenia StockOrderItem


Lista kolumn tabeli PhStItemBundleItem

Name

Code

StItemBundleItemID

StItemBundleItemID

Code

Code

StItemBundleID

StItemBundleID

LotID

LotID

StOrderItemID

StOrderItemID

Quantity

Quantity

PresentationUnitID

PresentationUnitID

StItemBundleItemStatusId

StItemBundleItemStatusId

AvailableQuantity

AvailableQuantity


Kolumna StItemBundleItemID tabeli PhStItemBundleItem

Definicja kolumny StItemBundleItemID tabeli PhStItemBundleItem

Name

StItemBundleItemID

Code

StItemBundleItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli PhStItemBundleItem

Definicja kolumny Code tabeli PhStItemBundleItem

Name

Code

Code

Code

Data Type

VARCHAR2(256)

Mandatory

No

Comment

 


Kolumna StItemBundleID tabeli PhStItemBundleItem

Definicja kolumny StItemBundleID tabeli PhStItemBundleItem

Name

StItemBundleID

Code

StItemBundleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LotID tabeli PhStItemBundleItem

Definicja kolumny LotID tabeli PhStItemBundleItem

Name

LotID

Code

LotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID serii leku


Kolumna StOrderItemID tabeli PhStItemBundleItem

Definicja kolumny StOrderItemID tabeli PhStItemBundleItem

Name

StOrderItemID

Code

StOrderItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Quantity tabeli PhStItemBundleItem

Definicja kolumny Quantity tabeli PhStItemBundleItem

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

 


Kolumna PresentationUnitID tabeli PhStItemBundleItem

Definicja kolumny PresentationUnitID tabeli PhStItemBundleItem

Name

PresentationUnitID

Code

PresentationUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StItemBundleItemStatusId tabeli PhStItemBundleItem

Definicja kolumny StItemBundleItemStatusId tabeli PhStItemBundleItem

Name

StItemBundleItemStatusId

Code

StItemBundleItemStatusId

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator


Kolumna AvailableQuantity tabeli PhStItemBundleItem

Definicja kolumny AvailableQuantity tabeli PhStItemBundleItem

Name

AvailableQuantity

Code

AvailableQuantity

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

dostepna ilosc


Lista kluczy tabeli PhStItemBundleItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhStItemBundleItem

Definicja klucza Identifier_1 tabeli PhStItemBundleItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment